﻿-- 面部基本数据获取
CREATE procedure [dbo].[RyFace_Get]
@sfzh varchar(18) = null
as
select mbsjlsh,sfzh,xm,sbryh,cjsj,ppsj from RyFace_Info
where @sfzh is null or sfzh=@sfzh
order by ppsj,cjsj desc,sbryh